Reconciliation utilities
These utilities are designed for budget reconciliation to the database.
The utilities listed in this section are located in \Axiom\Reports Library\Budgeting Utilities\Budget Reconciliation. For instructions, see Browsing the Report Library.
You can also access them from the Bud Admin task pane. In the Budget Reporting section, click Budget Utilities > Budget Reconciliation.
Budget Department Audit report
Use to resolve possible mapping errors at the department level by highlighting mapping and process management inconsistencies in the DEPT dimension table before building plan files and starting process management.
Click image to view full size
Budget Process Management report
Use to show what stage each budget plan file is in when using process management for budget staging.
Click image to view full size
Budget Workbook Reconciliation
Use to compare check totals from different columns in the budget workbooks to the summary fields in the database to make sure they are in balance. If the budgets are all in balance, then this report returns no data, which is the desired outcome of this report.
Click image to view full size
Global Depreciation Reconciliation report
Use to show the variance between the budgeted depreciation accounts to the same accounts in the general ledger budget for a user-specified budget year.
Click image to view full size
Global Expense Reconciliation report
Use to show the variance between the budgeted depreciation accounts to the same accounts in the general ledger budget for a user-specified budget year.
Click image to view full size
Global Revenue Reconciliation report
Use to show the variance between the budgeted global revenue accounts to the same accounts in the general ledger budget for a user-specified budget year.
Click image to view full size
Use to identify the JobCode/PayType combinations that have dollars but have no FTE hours for the year. This causes a matching issue because to create a JobCode block on the labor tabs, that JobCode needs to have YTD FTE related hours. This report identifies those mismatches and posts a 1 to the NYBKHA field so that the JobCode interfaces into that labor tab.
Click image to view full size
Payroll12 Hours Reconciliation
Use to highlight job codes saved in the Payroll12 data source from the budget workbooks that have hours but no dollars in the budget.
Click image to view full size
Use to highlight job codes and pay types that have any negative FTEs budgeted in any month. The report returns all job codes in the database, but only the ones with the Review flag need to be investigated and changed, if necessary.
Click image to view full size
Use during budget set up for payroll budgeting to show what PayTypes map to which payroll budget category.
Click image to view full size
NOTE: Prior to reviewing the report, your organization needs to load and reconcile the payroll data as well as complete the Labor Configuration driver. To understand this report, the user needs to have knowledge of the Labor Configuration Driver.
Running the PayType Mapping Analysis report
Use the following instructions to run and review the report.
- Open the report.
- Press F9, and select the proper Refresh Variables to review based on organizational needs.
- Review the following in the report:
- In the top section of the report, which provides an overall summary, ensure that all the pay types are loaded and map to a specific grouping. The variance should be zero. If not, review your PAYTYPE dimension table to see what pay type is not mapped.
- The remaining sections of the report correspond to the Labor Configuration driver set up and how the pay types are grouped/mapped in the PAYTYPE dimension table. These sections give you an overall summary of what pay types are grouped together, the overall hours and dollars, the FTE status, as well as the GL accounts if the GL is structured by pay type.
- Review the overall groupings to make sure they are grouped as expected. The bottom section shows what is not interfaced or coming into the plan files. Confirm that these are accurate prior to beginning the budget cycle. If you need to make changes, update the PAYTYPE dimension table and rerun the report to review.
Reconcile NYBDetail to Financial
Reconcile values saved in NYBDetail table to those values saved in the Budget Table which could indicate that values in your budget plan files are not saving properly.
Click image to view full size
Reconcile Payroll12 to Financial-Dollars
Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. It compares the dollars saved in the Payroll12 tables (Labor tab in budget plan files) to the values posted to the Financial tables (Expense tab in budget plan files). If there any variances in this report, they will need to be fixed in the budget workbook and saved to the database. The desired outcome for this report is to have zero variances.
Click image to view full size
Reconcile Payroll12 to Financial-FICA
Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. It compares the FICA dollars saved in the Payroll12 tables (Labor tab in budget plan files) to the values posted to the Financial tables (Expense tab in budget plan files). If there any variances in this report, they will need to be fixed in the budget workbook and saved to the database. The desired outcome for this report is to have zero variances.
Click image to view full size
Reconcile Payroll12 to Financial-Hours
Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. It compares the hours saved in the Payroll12 tables (Labor tab in budget plan files) to the values posted to the Financial tables (Expense tab in budget plan files). If there any variances in this report, they will need to be fixed in the budget workbook and saved to the database. The desired outcome for this report is to have zero variances.
Click image to view full size
Use to identify accounts on the Labors tabs in the plan files that do not have history on the Expense tab and would cause a balancing mismatch. This utility posts a 1 to the NYBKHA fields so those accounts interface in the plan files.
Click image to view full size
